from sqlalchemy.future import select

from app.config import db
from app.model import Province


class ProvinceService:
    @staticmethod
    async def get_all_provinces():
        query = select(Province)
        result = await db.execute(query)
        return result.scalars().all()
